clear
	set obs 1
	generate X = 1 in 1
	save $datapath/temp/outlet.dta, replace 

forvalues k=13(1) 19 {
	import delimited $datapath/pupld`k'a.csv, clear

	gen year=2000+`k'
	append using $datapath/temp/outlet.dta, force
	save $datapath/temp/outlet.dta, replace 
}

	erase $datapath/temp/outlet.dta
	drop if X==1
	keep if elmatcir>0 & ebook>0

*** create shares of holdigns from books:
	gen bookshare_p = bkvol / (bkvol + audio_ph + video_ph)
		su bookshare_p
		
	gen bookshare_e = ebook / (ebook + audio_dl + video_dl)
		su bookshare_e 
*******************************
	
